package com.nantian.nfcm;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.UnsupportedEncodingException;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;

import com.nantian.nfcm.util.BaseUtil;

import sun.misc.BASE64Encoder;

public class Main {

	public static String MD5Encode(String str) {  
        MessageDigest messageDigest = null;  
        try {  
            messageDigest = MessageDigest.getInstance("MD5");  
            messageDigest.reset();  
            messageDigest.update(str.getBytes("UTF-8"));  
        } catch (NoSuchAlgorithmException e) {  
            System.out.println("NoSuchAlgorithmException caught!");  
            System.exit(-1);  
        } catch (UnsupportedEncodingException e) {  
            e.printStackTrace();  
        }  
        byte[] byteArray = messageDigest.digest();  
        StringBuffer md5StrBuff = new StringBuffer();  
        for (int i = 0; i < byteArray.length; i++) {  
            if (Integer.toHexString(0xFF & byteArray[i]).length() == 1)  
                md5StrBuff.append("0").append(Integer.toHexString(0xFF & byteArray[i]));  
            else  
                md5StrBuff.append(Integer.toHexString(0xFF & byteArray[i]));  
        }  
        return md5StrBuff.toString();  
    }  
	
	public static void main(String[] args) throws Exception {
		FileReader fin = new FileReader(new File("E:\\user_info.sql"));
		BufferedReader read = new BufferedReader(fin);
		
		String line = "";
		while ((line = read.readLine())!=null) {
			String[] sql = line.split(",");
			String userName = sql[0].substring(33, 37);
			String pwd = BaseUtil.getMD5Encode(userName + MD5Encode("1q2w3e"));		
			
			sql[2] = "'" + pwd + "'";
			String writeSql = "";
			for (int i = 0; i < sql.length; i++) {
				writeSql += sql[i];
				
				if (i < sql.length -1) {
					writeSql += ",";
				}
			}
			System.out.println(writeSql);
		}
		
		read.close();
		
	}

}
